<?php
/**
 * Created by PhpStorm.
 * User:雨寒
 * Date: 2018/7/17
 * Time: 13:49
 */

namespace app\admin\controller;

use think\Exception;
use think\Db;
class Suggest extends Common
{

    public function index(){
        //标题
        $this->templateTitle("平台建议");

        //获取所有用户
        $list = Db::name("suggestion")
            ->alias('su')
            ->join('__USER__ us','us.id=su.uid','LEFT')
            ->order("su.id DESC")
            ->field('su.*,us.mobile as umobile')
            ->paginate(10);

        $this->assign("list", $list);

        return $this->fetch();
    }

}